Menu
If it possible to search in a table for records of which its name contains a search term?
Thanks
201
The SQL CONTAINS function for Oracle database The basic syntax looks like this: CONTAINS ( column_name, substring, label ); The column_name and substring parameters are the same as they are with SQL Server. Column_name is the column you are searching and substring is the string you are searching for.
CONTAINS is a predicate used in the WHERE clause of a Transact-SQL SELECT statement to perform SQL Server full-text search on full-text indexed columns containing character-based data types. CONTAINS can search for: A word or phrase. The prefix of a word or phrase.
Method 1 - Using CHARINDEX() function This function is used to search for a specific word or a substring in an overall string and returns its starting position of match. In case no word is found, then it will return 0 (zero).
SELECT * FROM `my_table` WHERE name LIKE '%my_search_term%'
or
SELECT * FROM `my_table` WHERE CONTAINS(name, 'search')
But be aware that the LIKE statement is very expensive. If you searching through a lot of text, you might want to consider using Sphinx for exemple.
185
Sure. There is the CONTAINS predicate:
... WHERE CONTAINS(name, 'search-term')
There is also the LIKE operator and some DBMS allow for regular expressions.
29
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
