kamal213 Posted September 19, 2012 Share Posted September 19, 2012 Hi guys, how can you get sql to select all cities in your database beginning with the letter C for example? Thanks alot Quote Link to comment Share on other sites More sharing options...
Jessica Posted September 19, 2012 Share Posted September 19, 2012 SELECT * FROM tbl WHERE field LIKE ('C%'); There are also string functions in mysql. Use the manual. And stop smoking so much pot so you can actually learn this stuff. Quote Link to comment Share on other sites More sharing options...
kamal213 Posted September 19, 2012 Author Share Posted September 19, 2012 Thanks very much it worked, problem solved Quote Link to comment 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.