Be seen. Boost your question’s priority for more expert views and faster solutions
Full Word Search Containing one word
I want to only get results that contain only @bob but my current query gets results with bob and bobby and other variations of bob.
$username = "bob";
$query = mysql_query("SELECT head.comment_id, friend_id, users.member_id, username, approved, UNIX_TIMESTAMP(date_posted) AS date_posted, comment_text, username FROM comments_head head FORCE INDEX(member_id), comments_body body, users WHERE head.comment_id = body.comment_id AND head.friend_id = users.member_id and body.comment_text LIKE '@$username%' order by head.comment_id desc limit " .$this->perpage) or die(mysql_error());
Asked:
2
2
1 Solution
change '@$username%' to '@$username'
$query = mysql_query("SELECT head.comment_id, friend_id, users.member_id, username, approved, UNIX_TIMESTAMP(date_posted
$query = mysql_query("SELECT head.comment_id, friend_id, users.member_id, username, approved, UNIX_TIMESTAMP(date_posted
@insoftservice: Right.. Just like I said 5 days ago! ;-)
@U_S_A: You might try using var_dump() to print out the fully resolved query string. Also, see the note about the MySQL Wild Card here:
http://www.tizag.com/mysqlTutorial/mysqlwhere.php
@U_S_A: You might try using var_dump() to print out the fully resolved query string. Also, see the note about the MySQL Wild Card here:
http://www.tizag.com/mysqlTutorial/mysqlwhere.php
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
'@$username%'
... to this and let us know how it works out.
'@$username'
I'm not sure - you might need to prepend the @ to the $username variable before constructing the query. But this is where I would start to test.