mysql searching with fulltext indexing

SGkgTGlzdGllcwoKSSBoYXZlIGEgcXVlc3Rpb24KCklzIHRoZXJlIGFueSB0 byBxdWVyeSBhIG15
c3FsIHRhYmxlIHRvIGdldCBpdCB0byByZXR1cm4gdGhlIGZpZWxkCm5hbWVz IHRoYXQgaXQgY3Vy
cmVudGx5CmhhcyBtYXJrZWQgYXMgRnVsbHRleHQgSW5kZXhlcz8KCkkgbmVl ZCB0byBidWlsZCBh
IHNlYXJjaGluZyBlbmdpbmUsIHRoZXJlIGFyZSA2MCB0YWJsZXMgYmVpbmcK c2VhcmNoZWQsIGkg
aGF2ZSBjcmVhdGVkIHRoZSBmdWxsdGV4dCBpbmRleGVzIG9uIGFsbCB0YWJs ZXMgcmVxdWlyZWQK
YW5kIGkgY3VycmVudGx5IGhhdmUgdGhlIHRhYmxlcyBpbiBhbiBhcnJheQpu b3cgd2hhdCBpIHdh
bnQgdG8gZG8gaXMgdXNlIGEgZm9yIGxvb3AgdG8gbG9vcCB0aHJvdWdoIGVh Y2ggdGFibGUKZmlu
ZCBpdHMgcmVsZXZlYW50IEZUUyBJbmRleGVzIGFuZCB0aGVuIGJhc2VkIG9u IHRoZSBmaWVsZCBu
YW1lIHVzZSBpdAppbiBhIE1BVENIKCkgQUdBSU5TVCgpIHF1ZXJ5IGFuZCB0 aGVuIHJldHVybiBh
bGwgdGhlIHJlc3VsdHMgaW4geG1sPwoKQW55b25lIGhhdmUgYW55IGlkZWEg aG93IGkgY2FuIHF1
ZXJ5IHRoZSB0YWJsZXMgaW4gb3JkZXIgdG8gZ2V0IGl0IHRvCnJldHVybiB0 aGUgaW5kZXhlcwoK
VGhhbmtzIGluIGFkdmFuY2UgKGhvcGluZyB5b3UgZ3V5cyBjYW4gaGVscCkK

Re: mysql searching with fulltext indexing

Bevan Christians wrote:

> Is there any to query a mysql table to get it to return the field
> names that it currently
> has marked as Fulltext Indexes?


|SHOW COLUMNS FROM sometable

-Stut
|

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysql searching with fulltext indexing

> Anyone have any idea how i can query the tables in order to get it to
> return the indexes

show indexes from tablename;

http://dev.mysql.com/doc/refman/5.0/en/show-index.html

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mysql searching with fulltext indexing

dGhhbmtzIG11Y2hseSBmb3IgdGhlIGhlbHAgZ3V5cyA6RAoKT24gMjQvMDUv MDYsIENocmlzIDxk
bWFnaWNrQGdtYWlsLmNvbT4gd3JvdGU6Cj4gPiBBbnlvbmUgaGF2ZSBhbnkg aWRlYSBob3cgaSBj
YW4gcXVlcnkgdGhlIHRhYmxlcyBpbiBvcmRlciB0byBnZXQgaXQgdG8KPiA+ IHJldHVybiB0aGUg
aW5kZXhlcwo+Cj4gc2hvdyBpbmRleGVzIGZyb20gdGFibGVuYW1lOwo+Cj4g aHR0cDovL2Rldi5t
eXNxbC5jb20vZG9jL3JlZm1hbi81LjAvZW4vc2hvdy1pbmRleC5odG1sCj4K PiAtLQo+IFBvc3Rn
cmVzcWwgJiBwaHAgdHV0b3JpYWxzCj4gaHR0cDovL3d3dy5kZXNpZ25tYWdp Y2suY29tLwo+Cg==