like

I have a fulltext field in my table. One of the rows is: "this is the dog that ran over there" I have the following mysql statements: SELECT * FROM…

I'm trying to copy data from one table to another. Here is my statement: UPDATE tblMerchants T, retailers R SET T.linklabel = R.linklabel,…

I'm running a query: $result = mysql_query("SELECT *, CONCAT(fname, ' ', lname) AS fullname FROM `users` WHERE fullname LIKE '%$keyword%' "); while…

So i am trying to do a LIKE query and get some results but the text that i pass has some special characters that break the query. if we assume that…

I'm executing an SQLite select statement with several LIKE clauses. The statements resemble the following: SELECT * FROM mytable WHERE name LIKE…

I have a pretty simple LIKE search for MySQL that i'd like to transform into a fulltext. The problem is i need to be able to implement it so that it…

I am attempting to query a table for a limited resultset in order to populate an autocomplete field in javascript. I am, therefore, using a LIKE…

I'm loading text files into my db and trying to do some quick matching between a table that lists names of organizations, and a table that holds the…

Basicly I have a row in my table, that has the following format for it's value - 1,2,3,4,10,11,21,34 etc.. I'm retrieving values with LIKE…

I'm on Mysql 5.0. I basically have a List Item table and a List Title table. For each Title, there can be 60+ items, which are all text. Dynamically…

I have a search that finds everything correctly, but my only problem now is that it also shows results I don't want to pull up. Query code below:…

I am trying to query: $title2 = (isset($row_DetailRS1['r_bus_name']) ? $row_DetailRS1['r_bus_name'] : ""); $query_test = "SELECT * FROM table WHERE…

Hello, I have this database where I have stored some tags in it. I stored the tags like this: "humor,funny,animal" Now I need a mysql query that…

I have a list of street names and I want to select all that start with "Al". In my mysql I would do something like SELECT * FROM streets WHERE…

Hey, I'm using this query to select data: mysql_query("SELECT * FROM products WHERE product_name LIKE '%".$search."%'"); The only problem is, that…

I'm trying to filter sql query by a word that is contained within a db column. This is working (Please don't tell me the Having is wrong... it…

After importing information about songs into my SQLite database, I want to use a SELECT statement to find all possible duplicate songs using this…

Hi Guys, I am querying a db to get all blog posts from a certain month of a certain year. The date is stored in the database as YYYY-MM-DD What is…

Hi I have a table with names (names). I have another that holds ids (user) . I have a conditional construct - a case when statement that is supposed…

Hi everybody! Same question as my other thread basically! I have a db table and I need to write a query that will return results based on a partial…