MYSQL: how do I select rows where a column contains a certain string?

[ocelot]

I tried

SELECT * FROM blog_posts WHERE keywords CONTAINS 'design' ORDER BY timestamp

but that gave a query error

[bobnew32]

You need somthing dealing with the mysql full text searching I believe.

[ocelot]

oh well see I need to have it find rows where the keywords column *contains* "design" but may also contain other stuff

so say I have a row where keywords = "ewoinfd cweowm wo design fwpom dwopkjo weo"

I want the query to return that row

[jam13]

How about:

SELECT * FROM blog_posts WHERE keywords LIKE '%design%' ORDER BY timestamp

[ocelot]

thanks jam that did it

[villar]

awesome jam :)

I had a similar prob to ocelot

I spent a whole night tryin to find the right answer and all that was missing from my script was a couple of percentage signs :: rolls eyes ::

cheers :)

[coopster]

We're glad you found us, villar. Welcome to WebmasterWorld.