Re: Fulltext doesn't seem to find certain text

[Blake Schroeder]

A guess, its looking for that string. Maybe should be looking something 
like it
example
select * from table where var like '%foo%'

-Blake
joe mcguckin wrote:
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52


 

--
+-+-++
| Blake Schroeder | Owner/Developer |lhwd.net|
+--(http://www.lhwd.net)+--/  \--+ 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

inserting works fine but I cant update.

[Blake Schroeder]

I am having a update problem, I have a table that has 28 columns they 
are name 1-28.  I am able to insert data into the table. When I try to 
update info into the table it does not work. Any ideas?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: inserting works fine but I cant update.

[Blake Schroeder]

Sorry
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near '1  =  '1' WHERE id =  '1'' at line 1

-Blake
|
Dan Nelson wrote:
In the last episode (Jun 09), Blake Schroeder said:
 

I am having a update problem, I have a table that has 28 columns they 
are name 1-28.  I am able to insert data into the table. When I try to 
update info into the table it does not work. Any ideas?
   

Not until you tell us the error message.
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: inserting works fine but I cant update.

[Blake Schroeder]

The type is a varchar.
-Blake
Ronan Lucio wrote:
Blake,
 

Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1  =  '1' WHERE id =  '1'' at line 1
   

Is the column 1 string type?
If it´s numec type. You should use SET 1=1 instead of SET 1='1'
Ronan

 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update problem

[Blake Schroeder]

Paul
Thanks alot that help out alot.
-Blake
Paul McNeil wrote:
You have to use
UPDATE MyTABLE set MyTABLE.1 = myValue.
Otherwise you are saying that the numeric value 1 = some other numeric
value.

God Bless





GOD BLESS AMERICA!
To God Be The Glory!
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: inserting works fine but I cant update.

[Blake Schroeder]

Dan
Great suggestion also.
-Blake
Dan Nelson wrote:
In the last episode (Jun 09), Blake Schroeder said:
 

Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near '1  =  '1' WHERE id =  '1'' at line 1
   

Mysql is seeing the 1 as a literal number 1.  You can force it to be a
column/table name by putting backtics around it: `1`.  You will
probably be happier if you change the column names to something that
doesn't require special treatment, though, like col1 .. col28.
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]