Just a quick question, maybe I'm missing the point of using merged tables, but why do
I have to use like '%string' to find a match from a merged table instead of = 'string'?
Example.
mysql> select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from combined_search where
PARTNO = 'DSB-C300' order by PRICE,STOCK;
ERROR 1030: Got error 124 from table handler
mysql> select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from combined_search where
PARTNO like '%DSB-C300' order by PRICE,STOCK;
| PARTNO | SUP | SUP_PARTNO | STOCK | PRICE | DESCR
| |
| DSB-C300 | tec | 143224 | 0 | 95.32 | USB WEBCAM 32FPS DESKTOP 64M COLOR
|DIGITAL VIDCAM |
| DSB-C300 | mer | 1621452 | 0 | 95.69 | USB WEB CAM, 300K PIXEL
| |
| DSB-C300 | ing | 119607 | 22 | 97.00 | USB WEBCAM 32 FPS DESKTOP 64 MILLION
|COLOR DIGITAL VIDEO CAM |
+----------+------+------------+-------+-------+--------------------------------------------------------------+
3 rows in set (0.73 sec)
--
---------------------------------------------------------------------
/ \ John Hoffmann Systems Engineer
/ . \ Professional Services VA LiNUX Systems Inc
\ . / http://www.valinux.com [EMAIL PROTECTED]
\_/ Linux Systems Work: (510) 687-6879 Cell: (613) 290-5217
---------------------------------------------------------------------
This is Linux Country. On a quiet night, you can hear Windows reboot.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
