Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : SQL Help

[cosmic_bird]

How could I do a keyword search of a column in a table.

For instance, say the column type is a string and I want to look for a particular word within that string.

Any advice would be most welcomed.

[packetnews]

SELECT *
FROM mytable
WHERE keyword
LIKE '%$key%'


Good luck,

[digitok]

Using the 'LIKE' operator

PHP Code:

mysql_query("SELECT * FROM <table> WHERE <field> LIKE '%<match text>%'"); 


Hope it helps.

[solidphp]

PHP Code:

mysql_query("SELECT * FROM <table> WHERE <field> LIKE '%".addslashes(<match text>)."%'"); 


Use Addslashes() to prevent SQL injection....

[digitok]

Ahh good point, didn't even think of that

[Tweakin]

Originally posted by HTTPeasy

PHP Code:

mysql_query("SELECT * FROM <table> WHERE <field> LIKE '%".addslashes(<match text>)."%'"); 


Use Addslashes() to prevent SQL injection....

Make sure not to think of addslashes() as a cure-all, you should do as much data validation as you can if your source is user input. Also, remember to make note of your magic quote's if working with user input.

Of course, this all only has any meaning if the poster is using PHP, which s/he didn't mention

[digitok]

Good point, I'm 99% sure that they're using PHP though

[W-H-Mtl]

SELECT *
FROM mytable
WHERE keyword
LIKE '% $key %'

You may want to pad your $key variable
at the beginning, end, or both depending
on how you want your search to function.

You may not want someone looking for 'cat'
to end up looking at web content talking
about catalysts catastrophies and categories.

my 2 Cents

[ilyash]

select * from tablename where keyword like (search string here)

put % in front for searches lik sdsadadKeyword
put % behing for searches like Keywordsdsdmsdsd
and put % on both sides for before and after like: dsdsdsdKeywordfdffsfsf

sorry for confusing you lol

[digitok]

haha, yeah that's right % is just like using * or something in say regex...