Alicia Posted November 10, 2009 Share Posted November 10, 2009 Hi, Currently I have a simple table with 4 columns. A, B, C, D If I want to find all the records with the similar value in column B. How can i write a simple query to match this one ? Please advise. Thank you Link to comment https://forums.phpfreaks.com/topic/180981-php-mysql-script-to-find-record/ Share on other sites More sharing options...
otuatail Posted November 10, 2009 Share Posted November 10, 2009 Need a bit more information on this one. Desmond. Link to comment https://forums.phpfreaks.com/topic/180981-php-mysql-script-to-find-record/#findComment-954863 Share on other sites More sharing options...
Alicia Posted November 10, 2009 Author Share Posted November 10, 2009 i just want to know how can I check how many records having the same info in a single column. I need to use the query in the php file. Thanks Actually what I want to know is how can I check whether 2 records has the same value under the same column. For instance. UserA and UserB as username in column A I want to check whether UserA and UserB has the same value in column B under the same table. How can I get a sql query to accomplish this in phpmysql? Thanks Link to comment https://forums.phpfreaks.com/topic/180981-php-mysql-script-to-find-record/#findComment-954921 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.