[SOCI] How do I enable soci-mysql and soci-sqlite3

[MadsTrel]

I have successfully installed SOCI via a manifest file:
{ "name": "soci", "version>=": "4.0.2" }
find_package(SOCI CONFIG REQUIRED)
target_link_libraries(TARGET PUBLIC SOCI::soci_core_static)

In my test-program I would like to include the following:
#include <soci/soci.h>
#include <soci-mysql.h>
#include <soci-sqlite3.h>

But I (sometimes) get an error in the CMake stating that the:
The following variables are not used in CMakeLists.txt:
MYSQL_INCLUDE_DIR
WITH_

And In my dummy project I can not find: soci-mysql.h and in my real project I can't seem to find soci-sqlite3.h either.
So is there some kind of flag I need to set for the MYSQL_INCLUDE_DIR to be populated?

Error message when building:
C:\projects\testVcpkg\sources\msqTest.cpp(7,10): fatal error C1083: Cannot open include file: 'soci-mysql.h': No such file or directory [C:\projects\testVcpkg\build\source s\Test.vcxproj]

I have attempted:

1. To install, find and link: sqlite3 and libmysql to see if they would populate it.
2. To add set(WITH_MYSQL ON) and set(WITH_SQLITE3 ON) in the x64-windows-static.cmake triplet

Any help is appreciated!

[MadsTrel]

Update (Solved)

My third attempt was to add mysql as a feature to soci
{ "name": "soci", "version>=": "4.0.2", "features": [ "mysql" ] }
This included the soci-mysql.h in vcpkg_installed

And I included the new available linker target in addition to the soci-core:
SOCI::soci_core_static
SOCI::soci_mysql_static

But now when building, it complains the library isn't available.
LINK : fatal error LNK1181: cannot open input file 'mysqlclient.lib' [C:\projects\testVcpkg\build\sources\Test.vcxproj]
But mysqlclient.lib is generated and is in the testVcpkg\build\vcpkg_installed\test-static-triplet\lib folder.

Even if I manually link it:
"C:/projects/testVcpkg/build/vcpkg_installed/test-static-triplet/lib/mysqlclient.lib"

The solution to that was to add:
find_package(libmysql REQUIRED)

Did the same for sqlite3 - works like a charm!