TalkPHP - View Single Post

WebSavvy · 04-01-2009, 12:51 PM

Try this:

Code:

SELECT `salt` FROM `users` WHERE `username` LIKE "beezm";

If your mysql select statement uses double quotes, be sure to escape any other double quotes used within the select statement.

Also, what version of mysql are you using?

If you want to wildcard the mysql search query and find usernames that start with "bee" you'd add the wildcard (%) AFTER the match to be performed:

Code:

SELECT `salt` FROM `users` WHERE `username` LIKE "bee%";

If you want to find usernames that end with "zm", you'd add the wildcard (%) BEFORE the match to be performed:

Code:

SELECT `salt` FROM `users` WHERE `username` LIKE "%zm";

hope this helps.

04-01-2009, 12:51 PM	#13 (permalink)
WebSavvy The Contributor Join Date: Mar 2009 Location: Springfield, IL USA Posts: 75 Thanks: 3	Try this: Code: SELECT `salt` FROM `users` WHERE `username` LIKE "beezm"; If your mysql select statement uses double quotes, be sure to escape any other double quotes used within the select statement. Also, what version of mysql are you using? If you want to wildcard the mysql search query and find usernames that start with "bee" you'd add the wildcard (%) AFTER the match to be performed: Code: SELECT `salt` FROM `users` WHERE `username` LIKE "bee%"; If you want to find usernames that end with "zm", you'd add the wildcard (%) BEFORE the match to be performed: Code: SELECT `salt` FROM `users` WHERE `username` LIKE "%zm"; hope this helps.