How to select multiple rows from a column/table in mysql?

Either you have another table "user" on which you can use SELECT * FROM user or you can use a WHERE clause SELECT * FROM user_new_post WHERE user_full_name like 'a%' ORDER BY user_date_post DESC to get all user full name starting with 'a.

You may perform a search for exactly a user name like this: $result = mysql_query("SELECT * FROM user_new_post WHERE user_name= '". $user. "'"); Or perform a regular expression in the query to search for user's name match your pattern: $result = mysql_query("SELECT * FROM user_new_post WHERE user_name REGXP '".

$pattern. "'"); Or use like keywork provied by MySQL: $result = mysql_query("SELECT * FROM user_new_post WHERE user_name like '". $user."'").

Multiple rows from a column is selected (without quotes):. Select multiple rows from a column.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions