| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|MYSQL: how do I select rows where a column contains a certain string?|
SELECT * FROM blog_posts WHERE keywords CONTAINS 'design' ORDER BY timestamp
but that gave a query error
You need somthing dealing with the mysql full text searching I believe.
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
SELECT * FROM blog_posts WHERE keywords LIKE '%design%' ORDER BY timestamp
thanks jam that did it
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 ::
We're glad you found us, villar. Welcome to WebmasterWorld.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved