ego0 Posted January 30, 2006 Share Posted January 30, 2006 I have a book about SQL 'SQL for Dummies' to be specific and I have found the keywords 'LIKE' and 'NOT LIKE' and I was wondering if this can be used in MYSQL syntax? (Need to know for usage in PHP script) Quote Link to comment https://forums.phpfreaks.com/topic/3284-select-like-something/ Share on other sites More sharing options...
fenway Posted January 30, 2006 Share Posted January 30, 2006 Sure... SELECT * FROM yourTable WHERE yourField LIKE 'j%' will retrieve anything that starts with a 'j'. Note that if you start with a wildcard, you won't be able to use an index. Quote Link to comment https://forums.phpfreaks.com/topic/3284-select-like-something/#findComment-11201 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.