Hi,
I am having trouble with getting rows from a MySQL table using the like statement.
I have a table which contains information relating to 5 cities.
eg.
table_name
City COLUMN_2 COLUMN_3
Bali ... ...
Vegas ... ...
my sql query is currently:
"SELECT column_2, column_3 from table_name WHERE CITY LIKE '%".$CITY."%' ";
where $city...
2 results in 0.0041 seconds.
-
How to use a LIKE statement to perform a search?
-
Returning value from Like statement in SQL server 2008 to vb.net
I'm in a bit of a pickle here. I need to pass the variable @uname which gets a value from a text box to a statement on one of my stored procedures in SQL server and return an output on my form.
Here is the code:
in .net
...Code:cmd = New SqlCommand cmd.CommandText = "sp_TransData" cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.Add("@unamex",SqlDbType.VarChar,15)
