Databases Reference
In-Depth Information
And indeed:
shell$ exiftool -Make 3881772447_d957742a33_o.jpg
Make : SONY
We can even search from the command line and display the found image at once:
shell$ display `mysql -N -e 'select * from test where match jpeg
against("easy street")'`
If
ImageMagick
is installed, the above command will show the corresponding image.
Alternatively, you can use any other image viewer instead of
display
. To make
these searches really convenient we can create a shell script, like this:
#!/bin/sh
display `mysql -N -e "select concat(@@exif_path, \
'/', jpeg) from test \
where match jpeg against('$*')"`
If called show, it can be used as:
shell$ show spiral art
or
shell$ show flower
A Soundex full-text parser
We have seen the "tokenizer" and "extractor" plugins. We finish this chapter with
a "post-processor" plugin. Such a plugin is interested in doing something with the
individual words of the text, but not in splitting the text into words. It puts itself
after the
mysql_parse()
function, but before
mysql_add_word()
. In this position
it can see every word and modify it if needed, but it will be MySQL that will do the
parsing job. Again, just as in the case of "extractor" plugins, this technique allows us
to implement only the main functionality of the plugin, only what makes it unique,
and not repeat the parsing code that already exists in the server. As an example of
a "post-processor" plugin we will create a Soundex plugin—a plugin that replaces
every word with its Soundex code, making the full-text search insensitive to typos.
