This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

UDF Regular Expressions for maria db

I've already asked here http://stackoverflow.com/questions/6659030/udf-regular-expreissions-for-maria-db

I've found this really good user defined functions ( http://www.mysqludf.org/lib_mysqludf_preg/index.php ) for using regular expressions in mysql However when trying to instal I get can't find mysql library

====== OUTPUT =====
checking for mysqlbin... dirname: missing operand
Try `dirname --help' for more information.
checking for mysql_config... no
no
configure: error: "Can't find mysql library"
====================

The site says

>>If mysql is an unusual place, you might need to add --with-mysql=<mysql directory>/bin/mysql_config

I can't find mysql_config, searching for mysql shows these directories

/var/log/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/share/mysql
/usr/lib/mysql
/etc/mysql/

I am using ubuntu lucid lynx, any sugestions would be greatly appreciated, thank

Answer Answered by Vladislav Vaintroub in this comment.

Answered on stackoverflow. You need libmysqlclient-dev (libmariadbclient-dev) package for mysql_config and required header files.

For Ubuntu 18.04 and higher: apt install libmariadb-dev-compat

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.